Command Line Parameters
ExcelPipe can be run from a DOS shell or from a shortcut with parameters to make it run automatically. This is very useful for
automation and scheduling (by making the short cut an entry in the Start Up folder),
and for running ExcelPipe from a batch file.
Here is a complete example:
"C:\Program files\ExcelPipe\excelpipe.exe"
"/f=my replaces.epp" /G /Q
Note:
- Any commands with embedded spaces must be surrounded with double quotes.
You must surround the entire command/setting combination e.g.
"/f=c:\Program Files\ExcelPipe\my
replacements.epp"
NOT /f="c:\Program Files\ExcelPipe\my
replacements.epp"
- Windows limits the command line length to about 260 characters. You can
overcome this limitation by using the /Z=<filename> command to load
command line parameters stored in a file. Note that you
MUST remove any double quotes from around
commands with embedded spaces when you put them in the command file.
Conventions used below:
<> surrounds text that is to be entered. Do NOT enter the '<' and
'>' characters
Alternatives are shown in square brackets '[' and ']' with a pipe '|'
character between them. Do NOT enter the square brackets or the pipe character -
just type the single alternative you require.
Usage:
"C:\Program files\ExcelPipe\excelpipe.exe" [/MINIMIZED|/MAXIMIZED] ["/F=my replaces.epp"] [commands] [/G [/Q]]
Where [commands] is zero or more of:
| /F=<.epp filename> |
Opens a ExcelPipe settings file. |
| /G |
Go. Begin processing replacements with Excel. Processing of the command
line does not continue until the processing job is complete. |
| /I=<filename> |
Imports a search/replace list from Excel, Tab
or CSV-delimited file, and adds it to the end of the grid. The current
options settings are used for each row added. |
| /Q |
Quit ExcelPipe at the end of processing. |
/Z=<filename>
|
Read command line parameters from the specified file. Very
useful for performing large numbers of changes, or for working around the Windows
limitation of approx 260 characters on the command line.
For example, if you had the long command line
start /w excelpipe.exe "/f=my special filter.epp" /g
"/f=my special filter2.epp" /g "/f=my special
filter3.epp" /g "/f=my special filter4.epp" /g /q
This would change to something like
start /w excelpipe.exe /z=commands.txt
and the file commands.txt would contain
/f=my special filter.epp
/g
/f=my special filter2.epp
/g
/f=my special filter3.epp
/g
/f=my special filter4.epp
/g
/q
|
|